﻿CREATE TABLE [dbo].[Supplier] (
    [Id]            INT           IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [Sort]          INT           CONSTRAINT [DF_Supplier_Sort] DEFAULT (0) NULL,
    [Title]         NVARCHAR (50) NULL,
    [WebAddress]    NVARCHAR (50) NULL,
    [ContactPerson] NVARCHAR (50) NULL,
    [ContactPhone]  NVARCHAR (50) NULL,
    [Projects]      NVARCHAR (50) NULL,
    [CreateDate]    DATETIME      CONSTRAINT [DF_Supplier_CreateDate] DEFAULT (getdate()) NULL,
    CONSTRAINT [PK_Supplier] PRIMARY KEY CLUSTERED ([Id] ASC)
);

